<?php 

/**
 * CoreController
 * @author lk
 */
class BibleViewController extends My_Controller {
	
	/** Wersy Biblii */
	
	public function bibleviewgridAction(){
		
		$this->_helper->grid(new Verse(),null,array(
			array('bv'=>'bible_verse'),'bv.verse_id = #.verse_id',array(
				'GROUP_CONCAT(IF(bv.bible_id = 1,bv.bible_verse_text,"") SEPARATOR " ") AS bible_1_text',
				'GROUP_CONCAT(IF(bv.bible_id = 3,bv.bible_verse_text,"") SEPARATOR " ") AS bible_3_text'
			)
		),false,null,'verse.verse_id');// TODO case'y tyle ile tłumaczeń...- chowac niepotrzebne kolumny
		
	}
}
